package phantoms;
import java.sql.*;

public class T1 {
	public static void main(String[] args) throws Exception {
		Connection connection = DriverManager.getConnection("jdbc:pointbase:server://127.0.0.1/StaplerzDB", "PBPUBLIC", "PBPUBLIC");
		connection.setAutoCommit(false);		
		connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
		Statement query = connection.createStatement();

		ResultSet result = query.executeQuery("SELECT sku FROM order_items WHERE orderid>100");
		while(result.next())
			System.out.println(result.getInt("sku"));
		
		connection.commit();
		connection.close();
		
		System.out.println("T1 done.");
	}
}